價格:免費
更新日期:2019-07-10
檔案大小:2.3M
目前版本:5.0
版本需求:Android 4.4 以上版本
官方網站:https://sites.google.com/site/mysqltlsaccessapp
Email:lmengual1492@gmail.com
聯絡地址:Apartado de Correos 47038. 28080 Madrid
Use MySQL TLS Access to connect to a Mysql Server from your mobile and perform SQL queries. It is easy, you just have to provide the IP address of your MySQL server, the username and password of your account and you're connected.
MySQL TLS Access provides two query levels: Basic and Advanced. In the Basic Query level you can perform queries like Select * from any table from your Databases. In Advanced query level you can perform different SQL queries like "Insert", "Delete", "Select from where" "Update", etc..
With an unencrypted connection between your mobile (Client) and the MySQL server, someone with access to the network could watch all your traffic and inspect the data being sent or received between Smartphone and server. MySQL supports secure (encrypted) connections between clients and the server using the TLS (Transport Layer Security) protocol.
MySQL TLS Access app provides a secure connection between your mobile and MySQL Server. In this case once the MySQL server has been correctly configured with security services, you must install in your Smartphone the Certification Authority (CA) certificate file used in your MySQL server.
Proceed as follows:
1. Copy the CA Certificate file in the storage phone (e.g., “CACertificate.crt”)
2. Navigate to Settings > Security> Credential Storage and select >Install from phone storage, select the file " CACertificate.crt" and install it.
3. Verify that the CA Certificate file has been correctly installed. In order to verify Navigate to Settings > Security> Credential Storage >Trusted Credentials.
We provide the CACertificate.pem, SR_Certificate.pem and SR_PrivateKey.pem files that you need. Also we provide the CACertificate.crt (The CA certificate in crt format) that you have to install in your mobile. In this link you can download Certificates and Keys files:
CERTIFICATES AND KEY FILES:
https://drive.google.com/folderview?id=0B8xK-sIfZogWdEJqcmNrb0lkQlE&usp=sharing
To start MySQL Server with Security Services you can use Worbench administrator Tool." We offer a video and screenshots which is described as the process is carried out. In this link you can see the video and screenshots:
MySQL SERVER SECURITY SETTINGS:
https://drive.google.com/folderview?id=0B8xK-sIfZogWeDZ3dEh6QVl1WkE&usp=sharing
We also provide a video as the process to install the CAcertificate.crt file in the mobile is carried out:
MOBILE SECURITY SETTINGS:
https://drive.google.com/folderview?id=0B8xK-sIfZogWRzdKaXlLXzJvTE0&usp=sharing
Finally, you can download videos and snapshots about MySQL TLS App
MySQL TLS ACCESS VIDEOS:
https://drive.google.com/folderview?id=0B8xK-sIfZogWQ083ZElJUHp5c1E&usp=sharing
You can found more information to configure MySQL Server with Security Services in this link:"
“Building MySQL with Support for Secure Connections”:
http://dev.mysql.com/doc/refman/5.7/en/building-with-secure-connection-support.html
MySQL TLS Access (v3.0) avoids using TLS handshakes cipher suites based on DH (Diffie-hellman) keys.
New OpenSSL versions has added protection for TLS clients by rejecting handshakes with 64 bit DH (Diffie-hellman) key length.
In this way MySQL TLS Access (v3.0) can connect with MySQL server versions before 5.7.11 using TLS.
App Web Site: https://sites.google.com/site/mysqltlsaccessapp